|
Fall 2022 Course Syllabus
Course: POFI-1349 (Section: 1H, CRN: 91346) Spreadsheets |
|
| Instructor Information | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Instructor | Adriane Champagne | ||||||||
| champagneam@lamarpa.edu | |||||||||
| Phone | (409) 984-6416 | ||||||||
| Office | Madison Monroe Education - Room: 207 | ||||||||
| Office Hours | Monday & Wednesday 8:30-10:00 a.m. and 11:00-12:00 p.m.; Tuesday and Thursday 8:30-9:30 a.m. and 11:00-12:00 p.m.; Friday at Nederland High school only 12:55-1:55. |
||||||||
| Additional Contact Information | |||||||||
| Course Information | |||||||||
| Description | Skill development in concepts, procedures, and application of spreadsheets. This course is designed to be repeated multiple times to improve student proficiency. | ||||||||
| Required Textbooks |
Textbook Purchasing Statement: A student attending Lamar State College Port Arthur is not under any obligation to purchase a textbook from the college-affiliated bookstore. The same textbook may also be available from an independent retailer, including an online retailer.
New Perspectives Microsoft Office 365 & Excel 2019 Comprehensive , 1st Edition Patrick Carey ISBN-10: 0-357-02576-8 ISBN-13: 978-0-357-02576-5 BOOK REQUIRED no access code. Access to a computer with Microsoft Excel 2019 required. |
||||||||
| Additional Materials/Resources | None. | ||||||||
| Corequisites/Prerequisites | Basic Computer Skills. | ||||||||
| Learning Outcomes | Identify spreadsheet terminology and concepts; calculate data using formulas and functions; 'create and modify workbooks; insert graphics; generate charts and reports; and create and use special functions. | ||||||||
| Program Student Learning Outcomes |
• Demonstrates professionalism in the administrative workplace environment. • Uses appropriate business administration skills. • Uses appropriate office software applications. • Creates effective business documents by applying ethical communication practices. • Evaluates business documents. |
||||||||
| Lecture Topics Outline |
Introduction to Course-Syllabus review, Online Learning Survey, Blackboard and Self Service Banner Managing Your Files- Getting Started-Excel Formatting Workbook Text and Data Performing Calculations with Formulas and Functions Calculating Data with Formulas and Functions Analyzing and Charting Financial Data Generating Reports from Multiple Worksheets and Workbooks. Managing Data with Data Tools |
||||||||
| Major Assignments Schedule |
Week 1 Introduction Blackboard, submission of Online learning survey 2 Excel Module 1: Tracking Miscellaneous Expenses for a Conference assignment 3 Excel Module 1: Tracking Miscellaneous Expenses for a Conference assignment (continued) 4 Excel Module 2.1 Creating a Sales Report assignment 5 Excel Module 2.2 Sales Report- Designing a Printout assignment. 6 Excel Module 3.1 Staffing a Call Center assignment 7 Excel Module 3.2 Calls assignment- Lookup Tables and Logical Functions 8 Exam 1 Module 1-3 9 Excel Module 4.1 Preparing an Investment Report assignment 10 Excel Module 4.2 Scatter Charts, Data Bars, and Sparkline (Sunrise) assignment 11 Excel Module 5.1 Summarizing Profit and Loss Statements assignment 12 Excel Module 5.2 and 5.3 External References assignment continued 13 Excel Module 6.1 Analyzing Employment Data assignment 14 Excel Module 6.2 and 6.3 Filters and Calculated fields assignment. 15 Exam #2 or MOS certification exam Quizzes will be given as needed. Schedule subject to change |
||||||||
| Final Exam Date | December 1, 2022 - 9:30 AM Through December 1, 2022 - 10:45 AM | ||||||||
| Grading Scale | 90 - 100=A 80 - 89=B 70 - 79=C 60 - 69=D Below 59 = F | ||||||||
| Determination of Final Grade |
Assignments/ Quizzes 60%, Exams 40% | ||||||||
| Course Policies | |||||||||
| Instructor Policies |
We will respect others personal space. Please maintain a six-foot distance whenever possible. Mask encouraged. Announcements: I will post announcements weekly, usually early in the week. These announcements indicate upcoming due dates and notes important to your success in this course. You should READ these Announcements every week. I also recommend using the BlackBoard app on your phone, with notifications, so that you immediately receive notices of new announcements for this class. Use your LSCPA email to communicate with me or call me at my office number 409-984-6416. Assignments: No emailed work is accepted. You must submit all of your assignments in Blackboard. Homework and/or quizzes will be given each week. The assignments will open by Tuesday at 8 a.m. will be due by 10 p.m. the following Monday night. This is subject to change. LATE WORK is only accepted in rare instances with instructor approval after meeting and documentation. Due dates are given and enough time is given to complete all work. Students are responsible for completing all assigned homework, including reading assignments, by the required due dates and be prepared for each class meeting. Students are responsible for completing all assigned reading and video viewings. A failure to follow oral and/or written instructions could result in a 0 being given for the assignment. There may be virtual meetings. These meetings are not mandatory. I am using these meetings as an opportunity for you to ask questions about the reading material and/or any assignments given. Day of week and times will be announced once class begins. Exams: Exams will be provided within a BlackBoard examination window. The exams will be timed and limited to 60 minutes maximum. Make-up exams will NOT be given. If you miss an exam, your lowest exam grade will count twice. If you miss more than one exam, those exams will be given a grade of zero. There will be a final exam. All students must take the exam on the scheduled date, and time, and failure to do so will result in a 0 on the final exam. Your exam will be graded immediately by Blackboard. Feedback on specific exam questions will be given 24 hours after the exam is due. You must work alone while taking the exam. Cheating on exams is not acceptable and will be subject to violations of the Academic Dishonesty policy. Textbooks/supplies: Every student MUST have a copy of the required textbooks by the end of the first week of class. The student will still be responsible for any assignments given. You will also need supplies to take notes. Academic Dishonesty: Copying, stealing, and submitting someone else's work is considered a violation of the Academic Dishonesty policy. Academic Dishonesty of any kind will not be tolerated. A student violating this policy will receive a zero on any assignment (first offense); a second incidence of academic dishonesty will result in failure of the class. Software Requirements: If you are in a course that is using a specific software, you MUST have the software available to you either on your home computer or you must use the open lab provided in the Gates Library. Reliable Internet access is required for all online courses and many traditional courses. Computer failure and lack of internet access are not acceptable excuses for missed assignments, projects, quizzes, or exams. DO NOT wait until the last minute to complete class work or exams. Do not complete assignments, quizzes, or exams on a phone or Chrome book as they will not submit properly. E-Mail/Voice Mail Etiquette: Students must use appropriate e-mail etiquette when corresponding with instructor; for example, complete sentences and a full subject line with your name/course name. Voice mail messages should be clearly spoken identifying students name, course, and any return phone number. Classroom Etiquette: The following behaviors will result in the student being asked during class time to cease the action and/or leave the classroom: using cell phones, talking, or keying while the instructor is giving instructions or during class discussions; surfing the Internet during lecture; and/or displaying a rude or negative behavior toward the instructor or other students. No cell phones should be heard during class. No blue tooth technology or recording of lectures in any format (unless approved by the instructor). No charging of cell phones or laptops in the classroom. |
||||||||
| Attendance Policy | Attendance Policy: Poor attendance is a leading reason for termination from a job in all areas of employment. With this factor in mind, the instructor monitors student attendance. In addition, attendance on a regular basis is necessary for proper skill development. Students should attend class and must log into Blackboard at least two times per week. If you do not log into your Blackboard two times per week, you will be considered to have an absence. Absences will be reported to financial aid and other campus offices per their request. | ||||||||
| Additional Information | |||||||||
| Institutional Policies | |||||||||
| MyLSCPA | Be sure to check your campus email and Course Homepage using MyLSCPA campus web portal. You can also access your grades, transcripts, academic advisors, degree progress, and other services through MyLSCPA. | ||||||||
| Academic Honesty | Academic honesty is expected from all students, and dishonesty in any form will not be tolerated. Please consult the LSCPA policies (Academic Dishonesty section in the Student Handbook) for consequences of academic dishonesty. | ||||||||
| ADA Considerations | The Americans with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the the Office for Disability Services Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241. | ||||||||
| COVID 19 Information | The Lamar State College Port Arthur (LSCPA) Student Code of Conduct COVID 19 Policy requires students who have been exposed to COVID 19 or diagnosed with COVID 19 to report their condition on the COVID 19 Notification Form (available via a link on the Student Code of Conduct COVID19 webpage). This information will be provided to the Dean of Student Services. In addition, this policy requires all students to wear face coverings in compliance with the criteria included in the policy. For more information please refer to the COVID 19 link on the LSCPA website. | ||||||||
| Facility Policies | No food or tobacco products are allowed in the classroom. Only students enrolled in the course are allowed in the classroom, except by special instructor permission. Use of electronic devices is prohibited. | ||||||||
| HB 2504 | This syllabus is part of LSCPA's efforts to comply with Texas House Bill 2504. | ||||||||
| Mandatory Reporting of Child Abuse and Neglect | As per Texas law and LSCPA policy, all LSCPA employees, including faculty, are required to report allegations or disclosures of child abuse or neglect to the designated authorities, which may include a local or state law enforcement agency or the Texas Department of Family Protective Services. For more information about mandatory reporting requirements, see LSCPA's Policy and Procedure Manual. | ||||||||
| Title IX and Sexual Misconduct | LSCPA is committed to establishing and maintaining an environment that is free from all forms of sex discrimination, including sexual harassment, sexual violence, and other forms of sexual misconduct. All LSCPA employees, including faculty, have the responsibility to report disclosures of sexual misconduct, including sexual harassment, sexual assault (including rape and acquaintance rape), domestic violence, dating violence, relationship violence, or stalking, to LSCPA's Title IX Coordinator, whose role is to coordinate the college's response to sexual misconduct. For more information about Title IX protections, faculty reporting responsibilities, options for confidential reporting, and the resources available for support visit LSCPA's Title IX website. | ||||||||
| Clery Act Crime Reporting |
For more information about the Clery Act and crime reporting, see the Annual Security & Fire Safety Report and the Campus Security website. |
||||||||
| Grievance / Complaint / Concern | If you have a grievance, complaint, or concern about this course that has not been resolved through discussion with the Instructor, please consult the Department Chair. | ||||||||
| Department Information |
|
||||||||